Title: SQL BT (By-BKK) / 00 Intro
Tags: Obsidian_to_Anki

Q: Expand SQL
A: Structured Query Language

Q: What does SQL stand for?
A: Structured Query Language

Q: What type of database does SQL work with?
A: Relational database or RDBMS (Relational Database Management System)

Q: What does a relational database represent?
A: A collection of related tables; All interconnected within themselves

Q: SQL databases provide what kind of storage for websites and apps?
A: Safe and scalable storage

Q: Name three popular SQL databases.
A: SQLite, MySQL, Postgres

Q: Which company makes SQL Server?
A: Microsoft

Q: Do all SQL databases support the same language standard?
A: Yes, but implementations differ in features and storage types

Q: How is a table in a relational database similar to another common digital tool?
A: It is similar to an Excel spreadsheet; We can retrieve it with code - SQL.

Q: What does each table in a relational database have?
A: A fixed number of named columns and any number of rows

Q: Give an example of attributes a vehicle table might have.
A: Model name, type, number of wheels, number of doors

Q: Which table model is shown in the SQL-Bolt introduction?
A: The Vehicles table

Q: Reverse card: A fixed number of named columns and any number of rows.
A: What does each table in a relational database have? How is a relational database built?

Q: Reverse card: SQLite, MySQL, Postgres.
A: Name three popular SQL databases.

Q: What questions can SQL help answer?
A: Specific questions about data, all alpha-numeric analytical functions.

Q: What are the main goals of learning SQL according to SQL-Bolt?
A: To answer specific questions about data and make better decisions choices

Q: True or False: SQL lessons include interactive exercises.
A: True

Q: What does SQL-Bolt recommend regardless of prior experience?
A: Work through all the lessons to build a strong foundation. Practice, Practice, Practice.

Q: What do later SQL lessons teach?
A: How to alter tables and create new tables from scratch, All mid-level SQL Functions.

Q: How does SQLBolt help you learn?
A: It introduces concepts and ends with interactive exercises

Q: Reverse card: Safe and scalable storage.
A: What do SQL databases provide for millions of websites and applications?

Q: Reverse card: Structured Query Language.
A: What does SQL stand for?

Q: True or False: SQL can be used by both technical and non-technical users.
A: True